package com.meituan.mapper;

import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Select;

public interface UtilMapper {
    @Select("select count(*) as monthSales from `order` where shop_id = #{shopId}")
    String findCountByShopId(String shopId);

    @Select("select count(*) as monthSales from `order_detail` where goods_id = #{goodsId}")
    String findCountByGoodsId(String goodsId);

    @Select("select ROUND(AVG(evaluation_score),2)  as avgScore from evaluate where shop_id = #{shopId}")
    String findAvgScoreByShopId(String shopId);
}
